/****** Object:  Stored Procedure dbo.spr_LoadDBEmployeesByPK  ******/

 use [TourIS]
 GO

 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spr_LoadDBEmployeesByPK]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 drop procedure [dbo].[spr_LoadDBEmployeesByPK]
 GO

 SET QUOTED_IDENTIFIER OFF
 GO
 SET ANSI_NULLS OFF
 GO

 CREATE  PROCEDURE [dbo].[spr_LoadDBEmployeesByPK]
 (
	@companyid int,
	@empid int
 )
 AS

 BEGIN
	SET NOCOUNT ON
	DECLARE @Err int

	SELECT
		[CompanyId],
		[Department],
		[Designation],
		[EmpID],
		[ExpiryDate],
		[FullName],
		[IsActive],
		[LogIn],
		[Password]
		FROM [Employees]
	WHERE
	[CompanyId] = @companyid
	AND [EmpID] = @empid


	SET @Err = @@Error
	RETURN @Err
 END

 GO

 SET QUOTED_IDENTIFIER OFF
 GO
 SET ANSI_NULLS ON
 GO

